class CreateItems < ActiveRecord::Migration
  def self.up

    create_table(:items, {:force => true, :options => 'ENGINE=InnoDB DEFAULT CHARSET=utf8'}) do |t|
      t.integer :course_id,   :null => false
      t.integer :pos_id,      :default => 1
      t.string :kana,         :null => false
      t.string :translation,  :null => false
      t.string :kanji,        :null => false
      t.string :audio_path

      t.timestamps
    end
  end

  def self.down
    drop_table :items
  end
end
